package com.example.demo.dao;

import com.example.demo.entity.ClassroomRentalEntity;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface ClassroomrentalDao {

    /**
     * 通过ID查询单条数据
     */
    public ClassroomRentalEntity queryClassroomrentalById(Integer crid);

    /**
     * 通过实体作为筛选条件查询
     */
    public List<ClassroomRentalEntity> queryClassroomrentalAll();

    /**
     * 新增数据
     */
    public int insertClassroomrental(ClassroomRentalEntity classroomrental);

    /**
     * 修改数据
     */
    public int updateClassroomrental(ClassroomRentalEntity classroomrental);

    /**
     * 通过主键删除数据
     */
    public int deleteByIdClassroomrental(Integer crid);

    public List<ClassroomRentalEntity> adminqueryClassroomrental();

    public List<ClassroomRentalEntity> adminqueryhuanClassroomrental();

    public int selectBysidNextSname(int sid);

}